﻿CREATE TABLE [dbo].[FormFields] (
    [FormFieldKey] UNIQUEIDENTIFIER NOT NULL,
    [FormKey]      UNIQUEIDENTIFIER NOT NULL,
    [FieldTypeKey] UNIQUEIDENTIFIER NOT NULL,
    [Name]         NVARCHAR (255)   NOT NULL,
    [IsRequired]   BIT              NOT NULL,
    [IsRemoved]    BIT              NOT NULL,
    [Options]      NVARCHAR (500)   NULL,
    [SortOrder]    INT              NOT NULL,
    [LastModified] DATETIME2 (7)    NULL,
    [CreatedOn]    DATETIME2 (7)    NOT NULL
);

